SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004920 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004920 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725794,947826,122916,211541,984112,602931,31770,883205,637898,408361,386022,92302,628398,547887,84923,676008,229953,458486,259150,334598,1020926,549268,843791,1026375,286015,421013,513585,31605,541958,395695,801988,1031612,468221,404128,221333,249980,979778,602698,331143,823549,665737,528421,503449,125142,319462,356121,150063,13821,894244,973001,624121,550537,983393,81190,202075,714467,534861,597109,1030556,599566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]