SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48844 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48844 [ RunTime:0.003274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730191,986731,819683,655781,656155,146468,339781,381640,546794,743717,764931,538175,790729,584440,1042014,475383,428404,724442,326213,996980,121395,502269,523037,237868,1005427,1002641,469081,51476,780054,386507,84437,91028,78850,90344,688658,850077,213199,1001006,844758,833252,562761,804303,35898,528539,112303,578563,718499,399570,76038,904105,64315,68109,443992,359602,416004,959013,302122,232588,936833,1037712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]