SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266047 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266047 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425577,770167,648929,315972,529957,521328,413599,938847,1037791,251886,597982,995375,784635,575965,485476,398578,211791,488438,389590,252547,711532,1031106,8983,294336,71686,81115,929359,19612,403952,648420,15182,800961,681110,1031951,168557,444883,394986,612543,601573,514690,162762,58237,727057,774150,488835,680579,678908,39656,903735,562513,633034,5697,171593,139381,264171,688803,173108,768816,89360,945330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]