SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402511 LIMIT 1 [ RunTime:0.000903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402511 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82843,1018811,234902,683774,836433,492606,1160,687927,234359,489763,58409,681680,702735,121143,401231,987876,1003932,5293,819346,778439,18710,99485,490481,779281,701880,313997,409646,255851,1005418,176453,817743,97771,689799,907674,984376,658569,726262,727887,609411,430792,172113,639233,1032868,24416,943540,247050,693541,732837,464414,940564,754933,448756,965953,250964,886968,590791,475827,36405,480556,339556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001164s ]