SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461017 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461017 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147367,201388,964648,885410,596974,720857,149827,506307,353190,210303,606229,989069,913375,235172,965161,2001,134765,232692,204045,900119,949096,613042,585392,434781,870733,1031411,767121,315814,887582,339642,665292,323380,522565,170246,1004539,873736,125358,500934,536466,217832,59695,829909,529729,341989,276076,928805,943031,688521,900116,105408,576440,383010,195258,787569,356566,99285,1046164,411401,934240,74661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]