SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544415 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544415 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206080,380642,990920,385256,1078,952310,236454,399627,940523,203778,927108,550420,332928,690660,144272,166657,637231,269578,929199,33722,250085,501792,485351,2511,422393,303003,1009141,884195,316635,21192,65059,285841,17082,711710,148912,548312,119085,746832,930942,261751,697625,401067,837556,515847,1040270,389752,971201,764541,162243,724469,514064,106520,459034,441110,628656,356294,158003,62621,760740,673397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]