SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43177 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43177 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031094,36770,337804,866171,717302,549541,949544,46159,58948,980229,297937,894270,346856,367970,676224,77032,1026079,1002096,939409,916157,644122,446817,652911,852776,47421,241102,178177,21035,914435,901226,659534,344448,1014158,348019,969804,517646,390838,586274,514242,522896,63313,339343,766702,9233,874723,846884,237142,897529,640036,284508,825768,821753,212252,290063,92670,536896,338597,476128,374488,637679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]