SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565918 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565918 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253014,5705,772506,960403,391243,857697,494354,28316,301085,102178,161205,202484,941573,486356,220202,544798,601493,467771,905364,127915,234095,802245,947485,797241,507147,895863,603987,659757,1046075,150655,348890,801916,558592,1040935,651900,166891,445290,1021990,997149,920645,545335,30479,724823,320277,781033,44664,69539,629490,726537,846108,381719,346098,495368,61205,653432,20608,88011,409632,532680,793789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]