SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505171 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505171 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74880,612616,689942,705317,58684,92756,352314,478512,881587,923741,410259,805322,172196,503382,613924,53955,87496,460925,131814,1039876,145813,255887,72192,358095,818125,65591,950480,912442,98182,443320,47822,613915,185287,746,896580,745884,812776,1027414,91248,327228,703460,234820,598165,974797,323262,644944,334582,1002514,542489,345215,270453,182677,319698,215452,646561,290207,400924,608616,692083,1033064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001239s ]