SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264421 LIMIT 1 [ RunTime:0.003920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264421 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506339,307897,877076,228304,441973,79102,818672,995397,9216,52979,758438,268619,121187,488320,303757,691103,57610,270436,212286,639069,120008,1016359,339463,41890,894533,973849,158256,373805,614526,137052,1001642,125748,549577,293046,1041424,887603,60598,930787,101771,607990,351175,742443,343100,481455,1044170,21600,58036,274532,795691,522494,444205,139826,61270,834824,871563,425647,107730,734314,103326,798757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003574s ]