SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003784 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003784 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517987,951581,346419,305437,489804,542195,25998,807936,836453,200494,661287,531877,1018390,618445,317169,197150,52913,921424,504985,355118,757167,179071,666934,581934,542493,558194,512278,790914,460531,29261,213573,579130,521721,149057,531690,456513,750397,698046,187791,850865,199954,79135,219482,378139,413939,75706,856024,231812,148396,61944,913582,600718,375765,322297,168862,375100,536444,103415,311124,932770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001566s ]