SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265843 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265843 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636584,473201,400239,443164,221945,852752,463769,981208,186635,104197,555209,245879,724072,456647,773748,97031,734359,553317,649367,54376,277828,602197,501855,346647,579067,806980,764784,156616,706395,972687,412395,376234,45961,375174,182133,115384,485101,828289,87672,32305,859234,992738,127462,122140,387557,802703,366365,301363,697117,518699,129269,939711,379599,172419,278323,859721,3044,985614,576858,23775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]