SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328440 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328440 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111187,333880,84591,20924,388297,523011,170159,16759,191969,323665,775456,929013,204333,1008629,970503,499799,863145,818848,919452,282178,813742,160284,223672,901664,262180,984926,121820,53408,149225,581433,586880,17511,340551,634539,242900,705003,985602,637574,439104,1048072,808164,264412,369681,574361,845722,70817,280119,410296,311606,303189,18439,942740,347677,746548,514006,809452,268639,413219,341844,473636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]