SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567623 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567623 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821505,181289,343526,1023650,968796,249350,135416,348763,334061,78838,831832,954203,392937,790950,993882,499629,691105,29314,578868,361952,910695,209059,473060,295755,291267,50501,947682,130483,929783,806977,659881,798781,484510,519433,598287,140674,818842,484921,1009052,196894,492059,1033962,513570,472667,401977,568250,117648,611406,657199,756150,337997,598827,529588,962148,966963,959038,1021902,918071,456488,199656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]