SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419122 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419122 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614836,213345,149532,411893,1042028,750443,257663,818597,318066,627212,503579,335366,773196,110541,894656,974577,211123,179671,322993,638889,116078,640384,102315,707592,224097,458056,702757,19684,32647,556399,232567,189453,480329,583058,258128,216134,240999,848692,147913,445904,96271,445262,599784,354328,366222,730088,481848,867763,443931,657779,640365,678645,426250,612700,443776,858306,435633,771059,332472,76351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]