SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411599 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411599 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445311,1012555,205469,506854,764259,677806,244768,557148,284884,937680,412488,423785,591567,455585,648035,691707,918722,536447,960641,255311,643545,93702,522201,647637,706836,101080,556538,444794,502579,971795,491521,170435,87734,666960,769114,363287,747773,806552,897085,1013363,555532,667305,72242,128748,837767,256396,810127,886150,140300,854696,219296,265959,99060,399067,869199,177042,333830,118511,456769,739119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]