SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41407 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41407 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826770,924614,560766,742792,870324,440845,642091,925827,543503,560416,2426,592712,848135,953579,579761,339842,275958,242567,810030,229610,930445,287624,398205,286411,456167,598386,89304,213351,858016,299216,1047325,342121,416908,241351,871095,789307,881011,919489,264478,764372,738589,767806,316506,180274,872780,416087,221402,898880,191820,891282,1010597,998508,349541,459852,513729,814916,564093,822270,143860,892747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]