SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409245 LIMIT 1 [ RunTime:0.000622s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409245 [ RunTime:0.005338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261134,503210,289142,76343,187745,28797,522984,956241,24041,527690,577557,381761,410845,732121,866772,21685,788362,103803,155845,671242,747329,721709,397778,603999,775669,430789,501827,356335,701916,58971,149509,816990,122473,523222,459025,395459,1024156,953895,255477,479784,125922,265248,221933,901054,304669,666065,724228,831627,76361,986568,52713,164784,442492,189905,953613,644495,987759,227100,690482,80608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]