SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105320 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105320 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180986,822586,347074,554623,348181,209913,509107,673552,737167,804746,661787,323729,325428,160783,769161,814528,960410,193128,326215,30474,216257,127273,886892,572931,369937,518552,135282,711072,754143,703581,475241,564478,675633,572006,1035117,726113,603246,154764,1026919,581602,374256,320978,815224,942701,677161,438492,671147,570972,575253,990451,764228,866362,200887,172254,663106,105644,483145,808408,545117,60273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001052s ]