SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399645 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399645 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101213,126127,732469,775530,258178,184025,257227,868200,232717,666406,754471,523776,582443,849954,30009,703938,190762,654897,404460,639223,693434,192474,160901,839292,588533,771960,372705,491146,986111,673105,843553,690805,137537,116165,813136,1016169,783417,205119,10391,14812,714591,372246,253191,765075,300628,900728,12534,452985,402690,945646,216548,435557,632833,545525,1047584,539654,578016,409724,407170,834956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]