SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201378 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201378 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110832,299223,92477,282639,393583,294625,725092,744769,929495,345510,32284,627286,443882,204717,23571,356679,242352,770544,743630,767926,537068,638801,280699,832499,102579,861898,284177,994274,489667,660378,930187,640138,315194,221407,34366,314670,345087,459996,947410,542113,290814,812130,403653,765670,773306,2891,574618,73300,189775,162501,690745,581977,125249,292904,994890,856079,490092,75571,817885,701732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]