SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501682 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501682 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936793,75102,1042304,1027667,160144,476931,377829,610668,971989,750108,114025,271812,918713,828537,487419,535009,132243,172597,540211,1025848,909460,1019575,86519,909760,486223,473191,887758,132330,409496,608243,886158,374671,549793,548907,180816,341060,426281,391859,162847,929769,937398,306957,709274,785165,594580,1023846,459517,306949,440547,1024146,142121,690499,829723,365381,119312,241026,63766,168276,952592,632555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]