SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563680 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563680 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942054,428932,106280,130087,280436,726259,983572,377887,327026,694039,975051,995083,91043,89086,447753,499571,87896,1046937,748444,418667,71516,691309,843430,315270,806976,454261,231400,665438,935628,47219,957364,509653,225877,839099,392499,293885,360179,439773,156375,72215,296712,608396,896688,324929,139937,479995,658308,1033267,722490,117784,1039306,15677,813115,625546,279519,113253,488426,793221,413733,5801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]