SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010223 LIMIT 1 [ RunTime:0.000707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010223 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145720,324218,200688,698275,267329,905708,288085,10304,849150,106096,574715,804802,110323,219990,274116,208300,238529,972907,305931,322522,798762,332369,189376,450808,998159,548648,169674,622388,832659,965105,703264,545527,289561,128909,1017122,699922,221712,110582,809050,895317,1035564,610401,606931,312525,647249,660571,381474,644686,172192,161834,836735,73049,964904,160637,765006,578473,1015723,343396,818812,558816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002063s ]