SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101368 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101368 [ RunTime:0.003076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795970,565975,887559,930546,595501,147045,408956,1028850,845538,698819,752223,891267,735899,316420,392152,681229,494059,567186,429070,338132,121745,95986,629695,646128,227043,1047473,918249,122033,289508,578809,734784,86052,1007911,410385,159021,156979,410455,879497,633313,319009,539469,713993,871663,859700,421746,234125,922537,962599,174636,714404,40532,1045972,538596,1016168,404878,1039305,312809,871819,363072,12033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]