SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545148 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545148 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745210,620459,585829,339440,620282,547421,131102,124779,310446,1006206,672261,512030,580432,620504,793125,624036,188647,1012234,283400,806867,254000,78052,1027220,76162,747362,448023,856934,942553,345778,361939,696259,825298,483210,130013,24435,778445,901788,752303,454408,891916,205934,766933,714842,587419,1010739,778224,321178,456370,800976,938104,618507,948951,998842,531359,269458,102066,300389,210915,521444,437595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]