SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 663809 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 663809 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270719,980238,62744,1000625,72412,817629,828388,605177,815047,152966,561061,1024189,62609,301516,640016,471161,21835,682312,475273,7556,41802,384654,353015,424931,847480,400351,576662,467900,675596,490981,572504,516407,146640,338327,360319,482755,89867,179784,64028,101498,205393,623700,847059,904491,106817,985340,1004928,13508,659634,161225,777542,709039,79031,523986,1044172,72055,1018739,406147,421748,755699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 663809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 663809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]