SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453934 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453934 [ RunTime:0.005427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984466,65289,41268,242562,46510,384605,431228,163103,301404,783408,784411,76389,696148,532143,595507,351913,671573,678367,917212,1015173,179153,942072,470435,532167,445760,855512,703163,883925,481821,507901,934682,367139,368313,380613,734228,426333,758081,506036,837603,1020837,101460,293354,138962,802812,174497,359640,366348,604129,854272,945146,1024021,354317,20765,590112,386164,288809,236538,1034034,992228,234575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002268s ]