SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 128409 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 128409 [ RunTime:0.003541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104505,910866,536436,82125,736603,403223,677057,968723,151041,857973,273757,951230,753113,666419,1035893,654860,687352,214772,19139,34846,608220,196248,67188,692877,891361,61304,862216,20576,808531,502814,61066,570205,588218,294421,966211,249973,625428,258744,143750,386895,81552,466119,962984,296783,1048652,1003598,618411,130403,540485,654449,75754,652540,537522,314108,473026,155062,947194,522162,202451,709759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 128409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 128409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]