SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401419 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401419 [ RunTime:0.002859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570717,440160,386753,369877,347680,590177,160107,25242,547625,327778,538678,175089,421708,28318,789975,673627,807919,754427,817755,927262,183730,746219,1046934,383646,443996,401827,575109,760582,548714,335253,174620,763472,163001,963154,729118,808211,987974,572952,433822,969617,259866,518591,780102,390979,815031,730912,427421,906536,952001,873428,183143,803308,587235,1024584,874508,901917,410970,102039,900466,390243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]