SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402198 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402198 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355282,1031898,79215,447489,273595,559417,316205,483574,756087,518426,867796,606568,287415,822878,541430,970578,575753,657394,293312,459725,251076,801331,186162,744456,83462,888796,575846,667965,871714,649988,639183,742541,989074,768575,674779,112733,12910,690542,384196,407770,975884,872650,136137,97863,358558,1001683,74009,590898,1046960,809343,384983,670641,144751,186314,522453,656732,246015,290614,1038952,388207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]