SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106535 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106535 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387032,629207,291,834408,453468,976807,395596,719344,787840,432812,708928,305027,838138,602762,567999,648045,584945,985328,562078,378929,691698,1021667,288492,281037,135964,871570,18248,127558,777854,826921,399002,708898,119544,377546,874831,357337,883501,756918,718562,547505,264897,550507,655932,605787,569955,670138,475902,670642,525233,214098,401031,796349,353348,551311,674529,637261,39407,123446,788600,936405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]