SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542598 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542598 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415986,589555,333356,268285,158920,347299,945473,1022716,941536,806341,1001024,811704,507776,304341,306180,481242,483066,717430,301415,341040,967593,677777,361518,263385,58878,238979,980808,501354,510766,267554,261354,943238,400910,766362,1048742,544249,140397,588759,1007050,1038766,23640,300989,1045633,339830,543099,163863,243942,621857,798476,487034,662545,1007179,454070,297773,68845,47203,787802,458365,752271,706541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]