SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681616 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681616 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305037,718239,220441,501702,393111,740649,983772,660093,410364,717399,359627,203396,495964,359645,59029,850002,402061,780137,523477,724511,112775,864588,860809,426915,803688,522087,124996,979351,195600,546126,746833,319661,571397,877340,63741,354460,902960,49001,781001,574585,997013,728867,176610,706498,1000426,507316,507893,645019,903074,400361,894739,562601,247973,278029,556504,168243,222133,414949,655389,289402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]