SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 361211 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 361211 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420999,513084,399490,652073,947097,863826,196788,340198,31713,611024,979856,277069,970704,30039,347319,844853,795834,333678,314266,910638,897105,84973,137647,344137,219972,286163,327025,503525,918244,974348,252316,12323,435361,698535,932161,135097,973259,118402,756793,172858,329846,798557,217789,378145,437870,774968,189533,733978,91292,634842,321633,984626,580895,417881,303147,207363,242944,681349,115727,676210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 361211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 361211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]