SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535948 LIMIT 1 [ RunTime:0.004734s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535948 [ RunTime:0.006218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926184,503958,671201,823273,818813,823331,550086,290167,167616,640147,730662,787127,108422,293867,291245,553737,486575,133522,886088,584200,747619,549222,98907,356676,578176,310344,591431,415079,645155,103113,408620,577572,323052,636056,345020,124082,674337,767363,182908,390180,615918,207189,244370,1025342,565405,355624,973919,56782,438101,262135,337186,834227,176734,602602,302769,734284,123775,804311,64670,302512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]