SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560424 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560424 [ RunTime:0.007506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745012,487399,317403,556105,923488,511058,108046,925665,438302,254431,818146,542745,762548,1024876,1014399,359654,118790,205641,773918,566531,638277,616960,635867,140372,394810,192421,168161,883769,631431,129328,408174,1046364,659406,907144,671636,542645,227450,211248,678505,1032992,356714,738326,639168,930350,246112,723771,69303,759935,499031,417844,163738,1033436,732065,757070,1024280,825052,673469,943785,753290,371473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]