SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035043 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035043 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466742,974322,389084,548539,993495,59639,549297,855578,937428,44483,362367,1006678,350221,333203,692390,604208,182391,874119,62261,719864,240160,643483,781553,228051,801246,129500,228481,227176,953914,447857,29126,297045,958185,572935,993420,122727,414856,379476,792355,374244,513103,465194,636528,582749,900819,304917,934966,983516,463077,241263,925348,1020062,409645,275721,321469,970190,950779,794973,682136,413908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]