SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005488 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005488 [ RunTime:0.004094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693386,63054,81853,182074,763919,567839,953494,584201,858537,695158,455393,572221,605097,976086,885814,1007555,33574,292594,925382,848394,728493,160071,942374,112769,745849,471946,242571,941629,442673,919595,774819,550917,707704,812357,649248,773122,584298,446290,40212,116565,74440,697310,143131,957217,247113,232082,528080,653880,134522,840059,828195,551303,1040003,793645,149269,498364,815990,38104,586580,399435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]