SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406422 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406422 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287872,923902,867047,648822,581811,920106,565148,921605,620179,435322,176840,259800,83208,811833,676018,581520,698120,970108,628554,583131,448963,445367,924555,541720,116264,151110,322378,512176,673462,100860,831674,196277,345535,943814,337704,11162,367930,310992,372745,15914,21966,723798,428153,523190,775919,890132,764315,631516,726147,12538,61558,946386,93419,425184,385254,584787,342818,910304,539123,35011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]