SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574535 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574535 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488146,1008091,327012,476550,401653,103877,42222,79800,735450,305403,624909,714624,645700,234875,306786,691874,842135,210689,73769,359947,33932,468522,166291,134293,1045203,233569,280973,75795,624456,643751,585141,210649,978132,700574,41643,527957,509134,214418,66941,769271,497007,684145,350903,366181,699269,20383,292234,285477,780074,247763,310932,308114,24451,1019353,528707,296111,685059,314797,723205,524134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]