SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440905 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440905 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538456,483154,1012808,1035341,831163,420619,154337,953039,356806,997682,309315,684503,645543,703029,57218,78590,268753,48389,788454,259265,806601,559544,924938,342998,351645,638438,183834,54445,320553,470860,887220,1003745,901799,9492,293850,958763,56278,847115,497104,10748,821114,107308,818031,1033399,793324,654271,1045236,263555,709512,572078,766602,1009426,509326,961673,473841,388534,454739,856348,365545,607654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]