SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465306 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465306 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476806,891586,981145,14637,31235,866493,230727,80606,888762,283053,713763,623814,528561,975714,953103,834552,1359,503452,749338,295592,338417,596059,630303,50063,580685,301209,505163,1023457,377329,142517,281413,481594,55041,988280,934356,868340,242476,974792,126428,422006,642932,314716,579454,423212,52028,1007600,843797,224501,639379,13480,45657,520164,783872,774538,945419,704435,741442,21018,640698,851288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]