SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310481 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310481 [ RunTime:0.002852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522060,608841,945780,820151,1002794,139405,78843,580504,572843,970668,961745,465454,936589,789169,428367,907699,924709,39781,27046,335987,707731,309978,25523,932172,737320,50356,30220,457859,929344,373582,953837,628269,966929,464274,53285,395416,481561,278491,673424,443159,75363,961770,846096,799541,866842,195641,1036112,237851,942406,283091,387737,568393,759902,1024339,1026679,528370,994686,482512,690250,663443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]