SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303208 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303208 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502241,477950,634770,600001,77600,433205,98410,549127,225280,104947,1011902,921773,488902,83330,587432,462077,574177,822886,879366,453528,885811,628641,1040679,590751,237633,581942,990209,791588,825185,1006921,867864,1034987,676242,54003,162674,234768,285836,71918,451976,953484,787934,357498,1000028,906600,879917,752505,809581,243213,432663,886284,790666,442205,445729,267025,476386,711572,999914,142571,948854,139944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]