SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447416 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447416 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619353,1043833,102335,915159,325236,305893,377256,891128,97668,484158,21899,721772,21931,16931,713863,648627,356768,739402,915845,562717,117601,854737,912905,306824,498291,738192,171843,420191,425993,257643,34789,113511,871187,515943,198966,186232,399966,990794,729885,117268,719405,151052,1017105,841367,771247,262278,729882,649378,862571,830203,246812,886181,767473,526923,889154,623727,224334,804499,799468,472751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]