SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029898 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029898 [ RunTime:0.004168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121417,893226,149341,481186,584604,337692,489983,291607,232704,626711,663109,213815,317705,130051,463059,370768,183024,654673,598601,367408,393060,47749,60962,382566,811927,593615,70072,860697,1007510,344578,297801,454098,180291,690370,993371,624666,602981,1037513,772868,285567,105331,842053,545670,864423,733445,526892,86111,535116,494639,845629,506134,883666,761450,345499,172313,119300,832300,1028209,261143,508163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]