SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034072 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034072 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719916,700641,779124,780699,284789,23712,250754,90451,922658,662974,51817,743989,836181,211896,7928,979184,430186,86589,584878,640811,1013173,541381,722264,951395,10806,716507,546176,267852,982290,993706,806358,908735,450346,580979,632991,390203,52860,369713,562855,45594,299816,4150,710723,199967,596633,473537,84460,297283,572686,978054,1026805,432620,237165,500233,445216,972675,471286,140039,315781,838336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]