SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580050 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580050 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105577,547547,848587,638369,920905,701486,47323,582874,572804,274758,763770,223567,547641,1046993,899047,181095,882240,569359,148082,519786,514959,764112,754088,797370,769134,76283,188955,384282,813580,361570,947741,740877,460192,28751,360254,993685,292906,849324,184778,189789,696180,632388,649353,177129,128626,413813,81013,328999,1010051,328624,395310,614003,125639,685793,964562,28593,946187,504852,738213,274991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]