SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319106 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319106 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905110,633163,692760,467402,169459,204389,584763,97511,528202,15378,950490,812615,443039,637650,170823,164099,828240,544490,788577,273001,697382,412717,990248,39689,391361,839394,994247,862261,470521,533999,779330,634794,603810,53018,18738,410957,620,333097,582545,145324,271636,819993,154257,462049,671298,106830,484739,769968,962456,659093,1009453,294531,579945,213242,1045392,523268,156414,419071,265562,379722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]