SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68725 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68725 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450003,226727,114067,301827,995420,115259,995170,574749,895467,35157,151789,90313,305167,616114,947354,614225,34101,681416,174619,1019678,5515,170262,1031557,444258,964878,473463,194657,758928,486303,220965,101252,534637,833531,395053,951522,264130,41055,467891,4667,627816,947232,442030,164516,61744,231418,610110,21287,415761,149144,748411,980826,494111,78168,65008,436751,120715,579137,792771,890174,231140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68725 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68725 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]