SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154863 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154863 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404216,199782,165330,502385,356853,495124,472076,404128,801082,454210,163492,503538,74162,187688,507897,938106,888568,90496,485803,33506,101944,881288,448842,222443,3017,168342,452961,91683,88518,111507,295655,843823,671101,54854,855248,138012,823690,528277,794301,741255,534480,330875,272706,549487,621822,894269,418425,448944,827069,368979,777812,545366,679909,197339,796346,382582,950353,641372,425214,167549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]