SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803836 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803836 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129392,526617,689798,495400,172745,772178,185573,476879,184300,63418,109327,939947,229655,818090,988416,58300,541650,1015917,296664,393191,132785,17787,780025,64466,575647,792164,937728,215015,848558,973677,220445,16938,247093,170252,869936,923537,1014618,854257,9244,534597,524543,664915,234114,249938,985511,985801,507144,916140,996776,142968,65610,530531,805583,566345,180628,934049,556227,109293,202417,35951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]