SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39812 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39812 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709922,921078,759648,1043244,77402,883615,929067,126302,46651,536381,688550,534009,141101,1035529,986756,204688,445560,5131,400779,539979,1005495,122967,619294,69176,926695,354779,855932,228350,636723,498617,198193,515866,777875,464442,40625,753545,466320,1046548,835828,139412,276734,376379,126013,187323,290865,588818,571650,62070,242053,924020,556331,965667,480095,772858,949998,780543,720939,67373,736372,504629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]