SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106434 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106434 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409134,412529,1044469,868476,679739,284086,444916,143459,313878,398698,762092,345231,638119,682017,512289,486779,197264,417701,774047,332173,306340,736820,941512,833505,939252,703362,556359,388472,535800,22148,333749,952514,178210,529611,990006,517373,657476,478763,151968,501502,199034,537652,1016778,606487,739366,1014267,290596,565885,457811,966633,470580,563233,234680,166822,824172,1040316,118457,558404,13384,1038098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]