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` = 648395 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648395 [ RunTime:0.000963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586670,105055,895169,861883,758557,836017,353248,982556,206857,14947,71678,861118,532824,257111,364576,1041572,16361,872237,161743,946099,262581,117827,404881,571426,941729,744012,905698,654101,820634,932713,669463,348218,511970,1014636,991892,102586,972437,310444,266724,868771,821974,224838,271360,234689,797058,111189,531665,881589,915277,1030064,269845,700416,275035,763950,598131,232656,685999,820791,487188,776154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001048s ]