SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009075 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009075 [ RunTime:0.001382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208974,279498,12081,116775,476392,241713,321056,519405,596160,773683,208166,943511,1042813,201349,441709,459105,947694,688721,366694,4757,963785,405390,622667,705002,64154,853873,1013966,1037397,803276,82871,871229,822844,155329,226735,934991,666743,1001937,521339,471325,160400,270303,759542,992416,511063,248471,625827,568907,571084,502019,1021297,760808,889806,398020,390962,203263,1006458,54159,238212,602515,67818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002246s ]