SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595160 LIMIT 1 [ RunTime:0.000797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595160 [ RunTime:0.004203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756043,1028695,439358,527952,198840,446736,921758,632571,187238,110202,448351,12875,293470,379223,37632,793806,813550,455809,1047172,139923,647666,509393,430988,532956,127336,332327,61160,584822,903836,883099,613196,387347,517471,1032225,725171,696010,754646,947023,61124,830300,85266,116795,311650,952158,993296,624089,101084,328196,885230,389199,561365,427436,245809,147655,531124,492311,225694,253000,893651,670235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]