SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002787s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505452 LIMIT 1 [ RunTime:0.000868s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505452 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249141,119559,889975,734654,694921,138605,178812,60951,407601,19868,750883,172999,1027647,309212,353946,241148,26821,380237,435647,625310,858539,45832,412181,14234,706198,411291,863186,683995,801810,773443,914960,844795,17979,446940,468598,61409,599587,214333,587969,172102,1043711,754102,187669,204389,667889,832934,623496,620568,701526,948843,716166,422162,525081,896128,204704,815193,850775,237804,402046,636212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]