SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566010 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566010 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023902,148299,674423,562185,365193,830386,892566,116829,848651,912163,638896,968166,689676,1018556,370196,711544,788040,947430,207591,882305,447796,707648,87874,666410,67010,641875,197240,36686,699897,571181,477727,742447,109008,892085,961758,446082,765645,368736,370762,152142,107367,837559,794004,915061,311535,589599,790596,204248,633985,552345,926301,488408,650864,231489,337625,738954,925236,98013,167014,348691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]