SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51540 LIMIT 1 [ RunTime:0.003663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51540 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043524,1042097,209673,1025833,878208,911191,51566,461952,626993,303514,785061,104360,212270,418604,610213,533031,458368,581973,1043676,531170,723446,259371,583474,441061,288963,736781,192475,183567,919336,653997,150056,432147,897931,305545,1047426,273831,1042235,857151,776814,72426,140006,316573,916273,187095,612685,531413,479807,367748,743392,285392,847571,450227,361044,167293,135120,760622,634702,342591,309932,466248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]