SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385812 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385812 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503244,208684,1030432,344381,868715,308261,500208,117859,511742,1028150,299953,313856,468163,286782,595579,890899,490145,171542,421028,85084,775204,338080,969923,926653,93778,503520,154176,134676,489105,219704,569062,523760,324818,182321,235048,86539,1038411,884710,1011230,902797,227413,210744,962400,909698,84265,295,894528,1033738,359802,508567,89842,865545,17751,730581,819803,620597,445883,274751,1026467,883481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001363s ]