SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344516 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344516 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999,112232,528868,1034862,590704,237442,357735,101797,611346,1029239,24690,406343,1025878,559207,998076,684060,45908,421771,1018994,920373,294351,435249,35381,1037208,562945,797814,140281,953093,659727,192358,477592,559291,765386,721194,395486,889831,960722,545272,799216,376137,350106,678750,692834,801290,283400,575338,630501,464576,129046,506955,139642,475144,128273,456643,808729,885033,138665,391071,1040171,456852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]