SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015431 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015431 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456482,255983,655223,407280,540560,931792,203730,840057,638743,556398,644481,697222,745566,328716,884393,128755,887301,102822,139052,1024184,293095,366717,802895,180264,659901,43524,556392,910439,682834,224328,322817,632166,948743,161711,899836,238296,962996,158590,216613,810745,137022,1012725,602577,384520,473592,366085,871041,466818,290807,741719,481711,399477,62329,947177,594809,964819,835077,630337,557384,650667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]