SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19018 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19018 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119482,10668,233277,907079,56538,679503,518251,713995,21411,775372,692855,460374,330544,248220,131769,622832,101545,339867,711892,619078,892100,907925,29724,23634,824029,211618,77771,247844,846438,143105,871976,902359,439288,407033,761953,669981,1035293,886086,978908,285026,124554,875679,377565,751461,575686,90066,525235,574,264891,447126,143196,24789,495481,786473,969472,924972,657011,183403,528704,815872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]