SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318513 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318513 [ RunTime:0.003366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10533,951344,603904,803661,999657,196581,960036,710618,782654,915425,170466,565450,364692,844886,979687,457286,108127,580392,1024575,463605,749586,449224,93058,688357,176557,122502,684497,884046,974481,893470,695563,811961,992772,230509,583437,395737,669121,87793,198703,891857,852177,1016721,391233,1013444,463607,554357,538433,743983,101251,946529,792577,1047525,979519,265640,703885,187463,158077,321048,788200,801212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]