SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403926 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403926 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282180,459911,190261,354976,602060,474332,923162,910157,191540,226688,346407,656538,792397,590622,494235,704997,181754,306942,186261,11253,782511,440788,77665,810074,18165,4323,292752,223873,904462,912697,708489,773169,836503,182429,734883,989645,581825,912405,44267,346705,515411,520944,672491,970556,997311,276116,505422,831852,88362,788574,315784,17940,633231,893620,107951,158442,353473,514723,901949,759749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]