SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031913 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031913 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544503,484442,34936,717022,364026,209522,262740,778422,538648,910143,918223,228851,122151,382882,392972,17363,535565,51531,1028908,951309,1002923,166161,792651,626797,672175,208653,215886,548326,34190,342182,191521,335383,646908,874658,305054,810070,304951,227643,873847,1040731,336797,575923,871412,704630,609970,29113,61116,684011,27087,996725,549029,938491,558625,265892,610342,717925,575195,326781,583609,1004978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]