SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359212 LIMIT 1 [ RunTime:0.000850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359212 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491453,540171,21225,272679,424377,1020822,503406,214018,255301,512498,730497,39648,108346,388244,77918,142131,462387,734489,1008331,321304,11593,404186,625593,760224,525978,10929,391097,568859,122007,664640,188206,893744,610179,406548,87061,773795,665497,183764,210604,98839,648555,956948,486628,457959,791741,626407,774405,568649,64766,110411,191461,159115,758504,473479,1002130,322555,335659,365774,613601,1001517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003354s ]